Conceptual data warehouse modeling
نویسندگان
چکیده
A data warehouse is an integrated and timevarying collection of data derived from operational data and primarily used in strategic decision making by means of online analytical processing (OLAP) techniques. Although it is generally agreed that warehouse design is a non-trivial problem and that multidimensional data models and star or snowflake schemata are relevant in this context, hardly any methods exist to date for deriving such a schema from an operational database. In this paper, we fill this gap by showing how to systematically derive a conceptual warehouse schema that is even in generalized multidimensional normal form.
منابع مشابه
Foundations of Data Warehouse Quality Source Integration in Data Warehousing
Source Integration is one of the core problems in Data Warehousing. Two critical factors for the design and maintenance of applications requiring Source Integration, and in particular Data Warehouse applications, are conceptual modeling of the domain, and reasoning support over the conceptual representation. We present a novel approach to conceptual modeling for Source Integration, which allows...
متن کاملEvent-Entity-Relationship Modeling In Data Warehouse Environments1
We use the event-entity-relationship model (EVER) to illustrate the use of entity-based modeling languages for conceptual schema design in data warehouse environments. EVER is a general-purpose information modeling language that supports the specification of both general schema structures and multi-dimensional schemes that are customized to serve specific information needs. EVER is based on an ...
متن کاملData warehouse schemas: a software engineering approach towards an efficient modeling of complex, dynamic conceptual schemas
In contrast to most traditional information systems which are based on a static, consistent view of transactional data, a data warehouse comprises several stages of data integration and data aggregation. Hence, the conceptual design of data warehouses addresses not only data structures, but also derivation paths. Integration and aggregation paths result in highly complex schemas and consistent ...
متن کاملData Warehouse Design and Legal Visualization – The Applicability of H2 for Reporting
The steady increase of regulations and its acceleration due to the financial crisis heavily affect the management of regulatory compliance. Regulations, such as Basel III and Solvency II particularly impact data warehouses and lead to many organizational and technical changes. From an IS perspective modeling techniques for data warehouse requirement elicitation help to manage conceptual require...
متن کاملDeriving Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems
In recent years the construction of large scale data schemes for operational systems has been the major problem of conceptual data modeling for business needs. Multidimensional data structures used for decision support applications in data warehouses have rather different requirements to data modeling techniques. In case of operational systems the data models are created from application specif...
متن کاملFrom conceptual models to schemata: An object-process-based data warehouse construction method
Data warehouse modeling is a complex task, which involves knowledge of business processes of the domain of discourse, understanding the structural and behavioral system’s conceptual model, and familiarity with data warehouse technologies. The suitability of current data warehouse modeling methods for large-scale systems is questionable, as they require multiple manual actions to discover measur...
متن کامل